SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284816 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284816 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468963,191968,697463,944308,300616,850519,273984,752326,84917,29377,962943,431445,988104,641537,491599,1017261,980303,249832,638490,185089,714996,924895,897117,463855,919632,207526,252971,727422,415583,513359,353857,949613,417829,486124,578306,408805,930156,800439,917396,128099,1022847,276427,446423,203704,192324,113498,516356,920132,94429,564343,826910,842228,434605,677315,779200,431147,749733,102641,95827,625082) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]