SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516539 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516539 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420513,645767,304771,766465,465385,748589,484558,606747,488217,971756,999522,591426,933027,650737,887205,845987,204732,548473,236408,755928,388256,924722,26326,248828,41759,613859,104908,796928,729830,399652,785757,590229,765537,508927,371323,295169,399497,139581,607979,57057,807648,679455,518412,771799,865682,105216,466944,971952,153213,561429,835901,22902,801020,1041078,203655,7916,120844,363168,491779,288298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002192s ]