SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314099 LIMIT 1 [ RunTime:0.001179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314099 [ RunTime:0.002037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420507,518503,304891,767179,502360,254360,31402,614990,659632,461730,801837,948766,751586,724122,172894,352078,343439,421415,740163,192585,379977,830993,705632,614922,552091,591627,791321,60199,436541,95379,495971,779154,320472,569234,770219,100640,465408,1016916,231757,844533,188854,466133,618650,543849,372693,569197,252123,772653,435193,625479,133429,48205,453736,394556,8722,106955,354015,811956,213304,832313) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001678s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]