SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482131 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482131 [ RunTime:0.003152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444819,601794,343466,1045889,911894,200403,502785,174030,753834,503268,274728,94461,552425,268618,389430,550425,867536,851204,869028,77392,786046,281736,161854,30944,913728,688341,832593,146259,1019551,40558,483851,852101,317802,136684,303646,945961,1008469,143995,3243,625683,742034,420848,602644,252133,984489,805877,1014626,896207,215824,306821,519130,36980,70972,1002411,731752,70612,889398,21342,219866,340462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001464s ]