SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 263917 LIMIT 1 [ RunTime:0.001990s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 263917 [ RunTime:0.001518s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034817,278435,850627,57275,298790,448679,373492,708827,582642,66714,44772,228979,643430,536617,453143,105393,440012,40232,1010479,601868,584181,606720,267475,188811,382072,891921,486884,158069,121190,879019,646617,553759,68128,789811,671089,784660,148372,902434,392274,799423,616136,857614,108008,924450,453485,407632,918520,244397,16995,467724,759336,203561,293216,929980,393683,265802,409642,400447,37576,529370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 263917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 263917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]