SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201670 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201670 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714843,268735,311397,386749,1002553,445778,814309,61316,671189,901411,456487,752727,770076,903278,728529,378035,669387,750013,252636,102660,456,797926,440626,853831,482671,655982,121379,781017,883580,192550,222861,460944,172121,385573,126015,823576,15955,395334,733034,179427,25337,694542,321283,96543,548597,1024348,336956,906333,952557,221656,845606,336488,893754,421925,720784,542898,682458,865974,609563,359527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201670 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201670 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]