SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345263 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345263 [ RunTime:0.002034s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540592,526099,11706,268855,832017,666759,459884,240951,491980,747491,604404,788076,656627,173562,406552,576296,261657,190904,47025,207016,674918,60088,591069,251030,25526,481187,514438,613511,234476,498014,453632,73784,660698,1026423,759748,754419,392428,236876,1024675,998971,106458,1005199,322896,135297,813475,252601,55049,180067,656273,295858,60087,384756,894942,245350,17823,998952,583348,147374,358289,641762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002490s ]