SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033536 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033536 [ RunTime:0.004255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782667,249347,175350,690608,278548,453236,838404,42210,496198,125186,637670,361547,6520,357176,915764,26285,437169,106533,103541,627591,1036556,579669,980442,414997,1012927,168626,970198,531045,322275,12442,1030109,191589,614093,861622,42923,847695,602026,921907,22860,610847,607279,722821,386964,505987,615050,213334,740464,229052,87055,1044572,711999,171423,311982,1038128,215593,74250,403907,864628,339202,319689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]