SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315051 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315051 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (163483,977553,711648,869013,77621,866458,89584,576882,761450,1019724,247241,52271,478499,438992,986140,252504,431762,636582,250850,774937,935841,572115,307496,221265,749432,233109,487553,75125,74974,389836,790152,97724,90892,303294,614733,750920,796203,161968,656302,74141,718085,830670,960842,192301,777513,243065,915437,25630,806528,654459,463242,50201,655639,683288,303695,758441,255454,46178,728453,73510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]