SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003005s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505660 LIMIT 1 [ RunTime:0.000586s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505660 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006375,208155,38285,66060,503720,1046098,1045646,472149,445944,396316,258599,158197,609126,154074,800501,263163,519144,1005668,772743,415388,520893,666364,220118,849128,419223,380242,777403,234902,313014,310201,511022,679523,58841,662855,801988,158153,871457,886519,394150,432556,402534,148918,579190,706663,752614,55158,449774,552093,452062,17543,999017,360380,984207,745995,793464,189166,824319,526189,727010,76731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002092s ]