SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399917 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399917 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333429,9046,191729,527209,709656,357948,1026054,883793,383691,1026960,5961,420667,18690,526338,167953,7802,441556,348534,883980,537101,393995,327282,38429,766736,157948,751928,158519,150584,842095,175028,540439,303712,69658,805176,1036240,315136,819963,593220,984458,85302,279058,157538,520999,474061,523017,1641,99033,998393,93148,144312,405393,886590,727285,234520,113410,111964,265490,268698,564000,646267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]