SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318908 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318908 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568028,504158,682414,117956,308798,635441,104181,344713,367754,353410,709630,508621,734615,637741,390910,88526,65018,1017832,268906,719463,380067,42447,880354,281365,259670,355426,314961,156351,883883,289177,223546,246855,566281,595600,287664,185626,1006508,1027492,921745,374030,374961,935749,701651,107668,44724,282810,123632,592503,746772,162521,560228,36926,1001371,1004058,308034,1010441,443045,250599,152155,499469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001380s ]