SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420791 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420791 [ RunTime:0.006135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (845336,74494,1014748,611,500137,591450,263999,635488,750047,421794,251606,550283,869147,1010778,14243,292662,2758,460226,309675,216621,439845,973525,619666,998065,862219,355028,962894,107117,836612,836969,269695,554448,541709,1030516,529931,899817,514025,963687,332606,445046,122185,892955,139151,331680,267101,631447,270458,1009887,389530,644142,884037,430888,21026,220862,387167,18594,457790,831015,74447,740624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]