SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001671s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50495 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50495 [ RunTime:0.002718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282044,102208,112919,91874,710489,571840,438635,898746,1010196,194024,10562,497229,647047,492407,436541,780841,544087,947187,503946,671877,653378,754116,233157,55299,387320,903048,848663,579888,835133,1045055,24448,115939,614308,286352,477862,682518,869557,936053,422050,205399,975609,338144,279651,262907,230047,825705,205969,9246,416831,432127,544363,823686,965721,260409,491137,947507,720359,524749,823594,434400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50495 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50495 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]