SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540291 LIMIT 1 [ RunTime:0.001078s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540291 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486730,354694,982971,104310,43881,543698,392965,1047892,48067,526807,228833,345186,1021742,397351,605568,585398,207938,217388,55116,708454,909739,89890,320844,133579,91750,223737,796539,191551,663073,486436,865962,825087,447031,635697,93688,791962,362595,57371,348308,988936,457731,260228,179380,619855,889713,594715,768600,575797,477759,158607,65667,801972,653766,378936,759645,791438,507434,462267,504966,723323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.020190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002016s ]