SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001876s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555911 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555911 [ RunTime:0.002655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719990,658476,530440,913893,455428,46932,406159,179156,28405,602114,331215,853089,1010704,25767,213461,360542,885691,679720,42585,245188,53415,659243,471743,436203,988710,518406,281646,906331,124877,514439,668973,726120,262520,534331,427159,562077,368914,313025,918240,910307,350046,550982,728169,126792,715519,687160,789654,979901,1001010,205741,1011464,109368,282158,968517,704673,955726,676512,692177,505570,1005408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]