SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 162582 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 162582 [ RunTime:0.003949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199716,935149,352709,583041,875298,532837,71969,861870,696546,272299,108068,801110,727403,732868,429227,809390,561604,709447,109443,854340,201780,868411,858667,562732,217534,312176,425962,204515,422135,733617,896664,861490,407912,151637,64454,535934,943541,569263,1020253,226434,588829,140657,1044030,639702,923135,173988,604561,340940,20083,629404,760637,17010,426782,142364,358958,32435,96492,410049,504241,1019411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 162582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 162582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]