SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 894510 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 894510 [ RunTime:0.006411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (224888,404243,69835,1044267,1035489,59295,969735,876627,419123,80131,278168,511788,11152,310373,892727,103579,137598,728221,320847,50949,24301,6110,739795,1012566,365469,519584,388801,294481,552947,195841,735647,94386,829854,338252,1041669,984206,813008,603835,823775,436022,1041027,54085,58773,980644,163745,867358,121824,2588,48005,1037794,685426,636843,40068,995392,769976,460760,874511,788875,995204,1029402) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 894510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 894510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]