SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047043 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047043 [ RunTime:0.001863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169996,544801,209264,291728,690988,796089,697967,1039013,137653,307730,34911,257636,450494,142483,9413,217225,322907,779929,812732,664590,673471,527416,404657,896145,38099,964308,126269,259898,406315,277724,259325,76468,594596,398398,1046573,710757,713433,414417,813679,503148,636919,156530,90038,450154,135025,341872,242132,914634,833908,968573,605247,266012,38685,213754,169867,770540,285612,1029837,694196,781862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]