SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002493s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38503 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38503 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5198,331744,298428,474496,1012437,800793,533473,742211,411075,288264,284976,955377,522782,838358,164062,466011,357331,620016,883974,485684,734308,203310,543534,962548,294900,389620,735253,678499,724068,459347,645163,204505,809070,475990,849259,866726,187263,895569,812374,860818,965677,13177,274336,269417,371989,783841,322988,535777,466205,161767,981714,364844,575901,128490,874377,890248,167607,720755,152063,322101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]