SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432299 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432299 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582428,163246,70014,1044627,458979,414187,945409,552141,473197,70862,256573,651636,33133,651906,114334,471289,595353,1023697,149616,604878,54486,221084,742818,178538,163485,332441,207524,577033,708930,319215,617832,168674,908472,511709,112706,637151,856543,858623,475608,600844,413592,999345,231849,1005222,56872,242727,234870,328087,156556,380429,185251,780813,888912,723997,23479,860753,281632,948856,859701,625701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]