SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 98100 LIMIT 1 [ RunTime:0.001815s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 98100 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (501979,45081,23099,861581,1035810,341578,817044,124689,154427,262098,975784,639899,587436,997174,674370,560740,1036079,290302,769718,907546,66806,340869,9386,701245,814431,185965,914117,97965,1024309,580545,702653,457454,836445,601955,523278,721200,87088,65571,214109,1017594,705503,5926,510754,869821,49380,260943,372660,565799,1037138,210771,748629,458470,392912,585351,472160,783285,376199,474743,269803,172748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 98100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 98100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000673s ]