SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104214 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104214 [ RunTime:0.002313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652582,464556,454498,207508,349174,1030629,176478,45319,493878,982026,609393,326927,463852,741689,265098,584552,295349,118574,423303,18087,938017,934956,7289,111271,461427,182791,1046817,642482,775392,413958,894086,120055,338120,93031,89567,686649,675972,573362,595943,533997,858790,773609,483400,665344,621840,193887,137636,174542,30698,721830,8280,718973,441205,634300,16191,334383,407796,868213,38672,458869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]