SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350176 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350176 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412055,804353,701489,556440,131873,258865,594558,1034581,726175,980864,396273,344229,578180,652480,36680,403383,543502,1000006,57828,902169,45311,214661,445851,1003947,58828,409312,588879,1004613,265662,229675,321000,621318,381221,406217,1010341,511530,403972,325548,78750,16709,518028,875828,688804,551530,153189,865101,804172,287296,657914,329655,221343,334214,514318,126687,252687,804987,276167,213188,1008952,308625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]