SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024043 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024043 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (19107,419522,593324,962867,177327,786632,785050,64488,63506,891593,730315,577850,620038,513682,499980,75130,834970,944518,115152,941198,824862,13705,325021,5735,954932,19895,61429,672587,812476,859253,190193,751789,139645,634662,423920,147803,330340,179925,233283,675767,549621,399941,17777,759038,3241,634882,982340,1035192,336788,936307,1036167,162809,736741,865624,486059,469199,653426,738198,135632,295957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001914s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002723s ]