SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 643905 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 643905 [ RunTime:0.001658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (132304,64097,704668,755160,937483,334834,141758,938229,706316,344586,489358,24362,35186,72180,138094,302046,1025012,455878,610726,451067,710267,153393,1031658,1014881,514872,862023,595018,128117,423712,751375,506402,419064,485627,520389,67167,904030,150607,898334,982452,348739,636010,2014,626339,193816,314510,310374,797681,37050,171994,625929,393415,362943,970368,945036,30165,710686,725386,288589,469575,679468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 643905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 643905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]