SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402303 LIMIT 1 [ RunTime:0.001034s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402303 [ RunTime:0.003483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427398,392172,977167,857470,192744,785680,829387,399990,166225,599409,483797,26790,152035,63313,323402,515538,792614,178501,374972,683319,125353,212372,505325,137931,490949,817819,164259,110004,229753,1022734,57547,105786,335587,398790,737966,575179,625293,902246,683428,58139,413680,263987,910994,366513,189471,404809,41475,896955,5048,431412,869700,462664,139124,688431,447849,257495,926527,735594,60633,137094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002410s ]