SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 881040 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 881040 [ RunTime:0.004767s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878936,861819,561618,265487,926340,240220,1024422,427572,42063,970716,49752,464193,73738,176106,226829,1012060,800001,894195,437528,584104,434698,793573,267862,115960,584964,705719,658185,734582,244456,333017,707547,154762,1034439,883841,138966,150190,763460,451095,144485,782487,362372,125685,1039207,233624,313736,91833,621459,551307,559361,469334,276256,214607,48689,628612,456752,229704,201899,741872,585405,365087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 881040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 881040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001965s ]