SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479404 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479404 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878225,209613,535706,295806,559431,855099,68368,756021,793575,455900,394043,713065,572258,528149,625712,1022939,828064,534411,409728,146772,243426,518930,263253,150147,909301,442752,18501,58253,564467,396112,339770,113502,767543,827263,203545,605797,186301,654965,490481,1042687,55176,839244,336784,384309,783771,573232,325648,181580,123839,361307,1034563,936066,83230,875732,572121,807212,269223,438121,894675,804603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]