SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674118 LIMIT 1 [ RunTime:0.000651s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674118 [ RunTime:0.005497s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280538,498142,160228,311109,479933,245616,193917,896161,430086,657137,366358,655381,328258,247762,777643,455925,805019,987314,793671,379751,921725,592051,39047,855597,165713,3052,293167,750358,340695,272180,47619,205462,537128,268223,893491,30019,221814,685643,917608,742748,100148,68686,557674,262464,33946,298139,858700,646254,939720,182170,405473,288641,203110,971955,266040,764179,696040,22957,477039,401652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]