SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002670s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465413 LIMIT 1 [ RunTime:0.000525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465413 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657293,899939,249396,40927,783787,579216,309678,342018,232929,612965,739227,41452,599502,836333,284575,609502,235061,875047,666664,817406,409889,974937,994526,981997,727202,653391,712111,1048609,195742,818363,458225,513768,61594,882779,880462,111549,814553,307146,125467,951566,455488,185992,615540,903766,943452,446706,983127,283980,672150,300211,788165,475893,983030,211603,938460,36528,595624,795500,755760,872499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000911s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]