SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001818s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 111510 LIMIT 1 [ RunTime:0.000733s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 111510 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (248382,211392,367225,882024,1011879,592551,1004484,269257,82472,838997,723107,115678,482775,268968,290977,471738,148424,758813,99353,336255,934478,505164,334023,764248,89956,26815,154636,816994,62409,869376,954833,674120,391049,733870,909237,757787,481112,229389,457715,334313,767482,833007,978318,1006225,247410,869817,305886,503415,603236,441518,551485,142088,282815,911167,14918,508379,887655,913938,317660,715438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 111510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 111510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]