SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 672043 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 672043 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (758063,830749,859903,887362,348688,503755,562014,491191,528105,509205,641511,585804,534841,767013,666525,255222,252863,848606,879182,814635,364558,476312,236907,622161,528817,765675,864940,682799,428904,263775,501006,830216,404434,939937,652419,494109,38076,694589,294666,16360,1048593,618458,27881,305734,802001,896145,805245,755856,98395,743017,827747,244540,577831,1028957,1045938,983052,833903,809934,794934,525621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 672043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 672043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]