SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445270 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445270 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1003162,881868,479047,488423,107833,385632,505295,375457,425907,1040016,484922,82463,636988,710522,82465,309670,10454,626831,85349,852636,494023,685978,262797,680010,713037,145701,94184,663999,867730,625988,66307,847947,142736,993007,653820,438616,152080,885248,665202,155976,370570,391247,944838,898871,505635,391789,540759,550887,993848,991658,329776,421764,541163,252341,31447,441247,624422,409911,292930,897740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]