SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414027 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414027 [ RunTime:0.003268s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509109,845467,901354,1021273,691334,292575,377586,135878,863562,196407,817364,60265,270310,475339,306795,239822,51593,683194,590141,888380,806024,201887,997933,978862,273126,686022,507751,732933,978872,387873,240260,984973,312277,809068,445441,117538,849341,448819,471709,721278,136089,399710,550052,696900,200865,52149,277400,376969,842082,1031005,128534,848638,512706,360890,537794,505693,609745,103062,747404,185227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]