SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 365320 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 365320 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470576,1000967,177110,289841,766334,962222,1015502,387564,576626,833480,1011925,682363,166391,99432,666129,884598,880151,61350,1018905,184678,438924,368379,997045,242911,609149,994078,160291,980181,606213,819501,268622,658158,494747,845553,229335,265741,957452,950299,733967,820497,452705,330312,504472,244858,755946,961750,816830,155289,401378,812771,631271,830425,751160,156103,222962,234738,1006306,561028,622272,364543) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 365320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 365320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]