SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001385s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294508 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294508 [ RunTime:0.003114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27738,77530,230601,53805,606336,374628,503107,828567,453726,415512,156588,335560,327835,914200,934855,747113,886009,266388,810728,890842,242780,100621,155371,699907,184786,2605,756182,241934,972471,627725,512805,1047662,913378,487358,418673,951765,1011240,787373,342418,930501,792276,908775,897954,420315,588451,783274,337820,727162,405174,1047880,445318,288117,188367,253526,369681,762677,414711,383291,860266,659016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]