SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027994 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027994 [ RunTime:0.001910s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663172,487814,449199,998398,558503,568028,917535,715660,27474,254119,573056,388740,712805,894129,301143,827775,584729,837941,537347,604277,590499,526012,23285,669630,454572,507848,315235,609025,8506,820102,809541,684423,22700,967901,43180,320447,94403,105622,237659,602948,1027741,813847,296489,220464,607186,913774,199367,343002,680486,503889,69483,623138,891272,235022,283348,87937,829610,252123,81872,346353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001822s ]