SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291063 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291063 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44486,613399,952126,608152,804684,196304,912598,119181,616049,547551,722948,225248,1011321,127243,279097,904726,351671,60577,60827,910297,881325,984178,269509,103123,34239,103750,323855,574273,26431,460976,60648,676412,532439,821645,825702,663507,570569,819927,564521,985566,732780,788166,823107,997979,1021078,565274,460875,669652,713798,352349,802123,679427,600638,631501,957531,620907,133900,975842,668279,223649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]