SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 357457 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 357457 [ RunTime:0.004342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (144893,95288,13934,647493,718441,946702,199293,665434,522723,653838,528254,644836,617389,491196,714354,644699,818018,177706,994325,697161,606413,259424,89004,702297,268684,457720,596431,601337,992109,422011,457093,512466,33860,624034,469587,801980,713978,431462,43703,772074,539543,93254,942875,488684,756282,628900,378367,400972,500405,264936,885068,31835,376772,380174,164740,70663,608818,196336,570962,848896) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 357457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000700s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 357457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]