SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681431 LIMIT 1 [ RunTime:0.000654s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681431 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762110,1011610,98022,1043793,375251,39472,1043836,140187,280950,930072,499119,443921,684312,609037,598652,745957,983516,974551,914386,268462,956330,485306,989148,121000,638407,599731,550444,626595,615949,993530,1015654,355066,401062,71072,666431,601628,311947,813314,4083,756085,702797,155741,137817,30163,402554,185205,930101,433932,529086,885197,182244,979112,478253,586695,458114,655881,900679,995466,614721,437501) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]