SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 154100 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 154100 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (230843,128233,65683,504947,1001445,707228,699069,545281,554288,91269,412939,130652,507279,172242,789142,565130,504498,543198,215171,484476,129410,637880,856791,396467,478398,389249,637965,256938,845338,1034958,448607,632951,101115,67288,587093,1006365,844435,227992,179710,617737,853612,906289,12611,214916,832485,115614,245799,473162,937333,1021460,531779,170013,531845,334944,759398,964944,177375,395626,745183,323087) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 154100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 154100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]