SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 704438 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 704438 [ RunTime:0.004161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229485,341029,452480,498239,754821,118169,1003858,706286,920498,470412,851469,320285,277542,858263,131302,241069,247151,930051,123060,403436,96884,543404,948974,955893,520901,756268,370137,52973,537845,934020,179655,264563,352518,843824,499949,351383,256889,628320,606943,864513,507157,254621,306069,286940,550993,85843,349296,746293,451667,49485,56249,983525,19386,709699,266460,361749,808605,457854,527145,361654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 704438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 704438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]