SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575473 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575473 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868629,583753,199604,146835,231595,1042674,320625,62401,736684,565973,626071,815723,756993,1013976,698080,364590,1014621,342512,726621,278649,12892,700635,910752,527186,267226,27285,644824,66575,271088,105084,865987,1025265,111469,1008469,110776,577200,1034231,680417,587691,516243,855887,589447,982608,538097,257423,346196,160133,562307,1000318,129795,938783,461359,63848,500017,790034,846219,570241,240170,260949,740607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]