SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318599 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318599 [ RunTime:0.002317s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815385,694354,231211,60929,1009813,710395,907020,203743,825190,2607,109467,381302,449078,5265,724991,774704,814322,356699,311967,387810,577518,455647,988476,661527,43672,984873,450297,836389,34349,532,506542,231560,931548,326955,119512,921205,793445,174648,399405,151010,579745,850389,817280,193804,371462,467667,971376,257111,283022,961470,507497,49481,308478,706529,900527,406892,733903,505402,595755,723460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003884s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000887s ]