SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 247611 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 247611 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (809326,717008,726454,840825,412881,340439,264579,170044,672434,328787,259907,836820,518462,694386,91594,952698,371488,284530,9639,232804,871820,31850,909297,531886,358594,268739,554698,113911,34023,415211,339813,836231,1011388,821582,9,318591,255945,123606,795618,663561,193106,231039,312410,462754,548407,106897,1027402,189117,310350,376599,766732,810813,509631,581477,441410,975654,469698,487755,665045,736249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 247611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000682s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 247611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]