SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406572 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406572 [ RunTime:0.004289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452122,960942,202665,360653,904941,154060,402814,12011,874768,751232,78766,707120,41925,874954,439496,993321,153954,609860,976909,295288,1037159,515017,121438,925949,73040,588680,808357,200817,88936,34550,887881,385050,502441,12941,557099,717772,412459,404887,747750,489710,190128,515153,209017,201168,395901,933463,420621,1037869,968892,171420,525093,804968,367158,129666,560559,658441,661249,1007409,635635,203620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406572 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406572 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]