SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480684 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480684 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220031,373073,426320,38204,704105,444125,587108,957075,438433,124646,112395,982584,175827,110614,527671,265259,876271,1005765,283306,435005,398224,743571,161877,687879,788901,199886,793451,796065,436059,304964,50618,34149,730054,928847,596498,457962,667186,786050,469781,874775,327237,636443,247081,173346,700909,419974,522100,389024,392349,51311,127994,500864,255598,154278,5180,280875,287191,935528,631880,379960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]