SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429203 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429203 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130698,788556,539594,633654,626395,342583,929328,7692,1005637,944089,788979,417546,532161,562818,747437,184175,338069,751353,164952,84011,261540,42617,878341,231138,793138,1027190,503005,220709,141114,930579,653080,564910,569264,787472,360795,882301,577999,929734,272001,566199,64190,381321,156650,683309,187475,964360,58227,747102,315667,959795,729452,228453,246024,654114,516648,780893,995636,312598,1021892,423292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]