SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497144 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497144 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458117,518537,506994,357558,361298,13871,967580,713840,804685,765783,144180,557690,522892,374856,470828,503461,167199,475257,251193,967601,325325,209570,675737,1032408,388931,219560,772598,574540,27104,253502,420812,177635,151233,708974,792273,485224,494325,744698,258634,260086,206430,40839,825837,1018204,945990,769918,661230,1004614,736584,769026,907478,263463,163199,650180,911804,161714,225027,12113,401151,184701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]