SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461909 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461909 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451648,854319,171431,910874,395089,114808,1046057,596745,587414,292550,213319,627784,311779,934054,514521,531944,618294,505354,724643,618858,460835,618466,418040,743254,531788,345290,601884,194997,862513,172940,702422,47544,254838,708643,730900,104107,45379,786458,478651,342569,1000668,65644,928691,410125,551431,461546,364091,1036561,770165,653783,546677,825122,167890,81283,973561,959079,373556,340027,103639,410161) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]