SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413728 LIMIT 1 [ RunTime:0.000771s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413728 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (937317,525129,804892,395929,374468,270256,877920,853510,453686,563788,511257,835507,805541,48448,99190,41567,50117,831717,120522,790263,1037047,223291,435691,515807,9356,767788,443019,934966,537259,406492,631258,276309,516364,474823,812178,431936,818978,636571,865873,424885,871910,608608,989333,885052,278190,604381,7458,307900,455533,973187,447812,527284,966305,684281,757333,796586,392691,205691,593920,1001500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]