SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538843 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538843 [ RunTime:0.002415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711825,794484,220421,873560,511274,975742,262109,599446,4405,150782,15292,840145,154432,202351,463490,544723,551030,795414,841737,759075,180489,794612,803901,49119,681946,247688,179367,166048,155786,1150,318389,369324,507551,314449,133876,514120,313295,921289,655551,1000937,799851,818687,686065,958430,364967,777069,376759,56211,541590,563759,910176,601126,227018,141713,453804,845189,585639,915320,831134,85392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]