SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042943 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042943 [ RunTime:0.007611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575905,382990,155295,781318,963511,511475,993283,38646,233245,553590,677110,701793,87626,96213,610700,203805,33937,927319,481204,89129,796999,221817,806116,875569,947138,517625,477939,217737,1000541,435100,613949,890841,127235,424902,1047144,273986,91679,529417,161712,368443,129550,442931,879273,124783,489000,227519,836428,735374,974109,122839,55740,193246,98567,988253,839790,998018,797767,817769,182799,894460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]