SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417423 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417423 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456540,468135,33584,55279,529867,95405,860765,247131,251828,1023132,961431,231785,589521,553872,837380,692708,838305,590,720470,19111,629302,364132,57417,470419,555808,291373,430206,906950,553527,864225,747285,16338,381925,400625,437140,196281,1012026,935580,442623,820486,170450,374991,460810,25736,327440,930706,130210,539150,34723,229911,282370,390328,121720,790194,85700,194675,649680,605370,828412,538665) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]