SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504405 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504405 [ RunTime:0.001405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276173,67470,12360,22678,40341,199566,951283,450558,158887,349374,835079,725131,292782,382363,119976,610427,682151,550202,354663,25651,171406,79015,491427,462008,566017,609430,137335,247903,902805,238115,293675,425990,140205,582525,128963,447250,418009,1009038,531399,260112,966579,975406,144585,1031385,414316,573385,96685,963316,795323,321113,557853,1045261,730789,697947,406466,650145,16990,980146,1042141,870142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]