SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509455 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509455 [ RunTime:0.002249s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (94703,1028003,885226,915775,804795,473238,1029989,648369,475392,906341,463001,940506,199606,230772,838353,820175,866540,555830,455558,688462,528488,442803,554906,496339,718460,616908,841034,363198,873469,222430,403077,102711,117473,890343,323396,860459,527880,984581,761996,642676,230357,81495,812715,115681,169082,296884,729569,993043,369920,570441,548977,393930,667659,1013499,761967,336545,88271,12850,597871,1017779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]