SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494306 LIMIT 1 [ RunTime:0.000776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494306 [ RunTime:0.004554s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (385592,376772,991040,1005593,696473,593795,285998,800701,130353,135588,188135,913379,927393,448887,185612,988023,112649,273820,300397,404715,85585,1043171,808794,529733,507891,734672,117227,782164,472396,486448,367736,162664,669746,891439,181094,442638,158184,874821,722501,366357,124823,630270,497442,318313,225235,968834,431056,515804,417172,878601,104754,308507,487453,589082,463490,57526,711008,367706,796532,599835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]