SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477263 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477263 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80476,442350,768701,94235,466112,497502,997356,404539,338967,266257,495549,891818,250879,930632,517604,917476,541314,66345,706523,671983,633811,176181,479221,405437,18775,541787,212097,840630,246852,584889,279686,999865,759183,525933,188090,588924,169319,240726,357601,472395,779666,114158,560163,738373,726619,853647,262998,107709,730995,96304,402386,34458,207542,324221,1023294,57400,743246,981571,349076,126192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]