SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506044 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506044 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634089,173957,908479,427172,920457,296128,106638,372769,293027,985389,511874,855283,999710,365710,178411,762348,669865,689598,574930,374472,123901,671568,205975,665702,841241,870011,251493,1017889,510383,77212,161912,161965,85893,64024,356913,59369,321183,392745,369769,924108,988013,333805,115211,937240,951113,380261,93766,590130,966213,703383,759181,43102,881514,124428,349256,505111,19999,668390,762363,953788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000999s ]