SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104875 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104875 [ RunTime:0.003109s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817132,160272,899281,289952,297589,226731,72773,134613,194058,397513,645517,782613,737354,608797,426018,450613,818761,133329,863290,354832,900503,435783,166280,314256,792385,139325,439239,352112,936089,960287,454248,668489,422842,63062,578617,1018446,312708,523506,963673,511016,331311,463471,656348,632723,460064,429907,266146,23993,365394,143516,987766,892894,285566,342004,401144,456741,164952,629415,775497,935930) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104875 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104875 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]