SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339724 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339724 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1031580,51149,502081,107711,494749,971644,160088,468989,1055,43681,325690,892121,530458,60384,630604,895797,198370,721275,192443,842811,209941,911441,641838,603338,916280,805140,445641,934909,1025868,1017581,487561,748546,151573,51617,142617,824556,898225,177633,462737,177593,522207,358386,72019,1036602,256959,1014682,634452,539438,683883,179051,989403,224093,853200,311573,677173,110840,281266,120992,812427,381423) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001701s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000789s ]