SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434245 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434245 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815234,474905,566623,887441,2894,311269,503965,656275,514440,356601,225352,5787,601081,713663,249428,936491,156653,632776,701900,203134,422404,696805,762674,967435,772994,597128,548702,855766,504466,55524,19796,1033938,88721,766202,918054,895918,1034804,406168,313737,488114,750607,403037,1037292,13156,482050,414770,976067,973000,455884,723095,252022,104279,631840,827693,247473,241689,764492,289408,887399,830097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434245 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434245 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]